Table 4-2. OLE DB Schema Rowsets Supported by the ADO Data Provider
|
Schema Call
|
DB2 UDB
|
Informix
|
Oracle
|
Microsoft SQL Server
|
Sybase
|
|
DBSCHEMA_CATALOGS
|
|
X
|
|
X
|
|
|
DBSCHEMA_COLUMN_PRIVILEGES
|
X
|
X
|
|
X
|
X
|
|
DBSCHEMA_COLUMNS
|
X
|
X
|
X
|
X
|
X
|
|
DBSCHEMA_FOREIGN_KEYS
|
X
|
X
|
X
|
X
|
X
|
|
DBSCHEMA_INDEXES
|
X
|
X
|
X
|
X
|
X
|
|
DBSCHEMA_PRIMARY_KEYS
|
X
|
X
|
X
|
X
|
X
|
|
DBSCHEMA_PROCEDURE_COLUMNS
|
X
|
X
|
|
X
|
X
|
|
DBSCHEMA_PROCEDURE_PARAMETERS
|
X
|
X
|
X
|
X
|
X
|
|
DBSCHEMA_PROCEDURES
|
X
|
X
|
X
|
X
|
X
|
|
DBSCHEMA_PROVIDER_TYPES
|
X
|
X
|
X
|
X
|
X
|
|
DBSCHEMA_REFERENTIAL_
CONSTRAINTS
|
|
X
|
|
|
|
|
DBSCHEMA_SCHEMATA
|
X
|
X
|
|
X
|
X
|
|
DBSCHEMA_STATISTICS
|
X
|
X
|
X
|
X
|
X
|
|
DBSCHEMA_ TABLE_CONSTRAINTS
|
|
X
|
|
|
|
|
DBSCHEMA_TABLE_PRIVILEGES
|
X
|
X
|
|
X
|
X
|
|
DBSCHEMA_TABLES
|
X
|
X
|
X
|
X
|
X
|
|
DBSCHEMA_VIEWS
|
X
|
X
|
|
|
X
|